Merge Table

../../../../_images/merge.svg

Merge Tables while matching an Index

Documentation

Definition

Input ports

Input A

table

Input A

Input B

table

Input B

Output ports

Output

table

Output

Configuration:
Index column (index)

Column with indices to match

Join operation (operation)

Column with y values.

Merge two tables or two lists of tables (database style) using these nodes:

Internally uses pandas.DataFrame.merge for More information see that documentation.

Essentially, this node calls:

pandas.merge(
    input_a, input_b, how=join_operation,
    on=index_column)

Values for Join Operation are:

  • Union, similar to SQL full outer join

  • Intersection, similar to SQL inner join

  • Index from A, similar to SQL left outer join

  • Index from B, similar to SQL right outer join

class node_merge_tables.MergeTable

Example flows